Hello Faizan.Shaikh
Welcome to ExcelFox
Inserting a picture with VLookUp sounds a bit strange. The formula function VLookUp is usually used to give some details from a table based on some Look Up value.
So it’s difficult to know exactly what you are asking.
Someone might take a guess at exactly what you are asking, but your question is a bit open ended.
I think you will improve your chances of getting a reply if you give more precise detail, perhaps with a small example.
Perhaps you could make a reduced sample size workbook for us: Only include a few lines of Data. Show us the data as it is , and then show us again how you want the data to look.
In other words show as a Before and an After
(You may want to change any real person details to imaginary data)
Alan
Here is a simple example of VLookUp in use
_____ Workbook: Konnto.xls ( Using Excel 2007 32 bit )
Worksheet: Sheet2
Row\Col Product Cost What do Yous want ? Cost Apple Apple Orange
_____ Workbook: Konnto.xls ( Using Excel 2007 32 bit )
Worksheet: Sheet2
Row\Col Product Cost What do Yous want ? Cost Apple Apple Orange
If a customer Types in cell F3 the thing he wants
, then the formula looks for it in the first column of the table B3:C4
, and then takes the corresponding value in the 2nd column of the table B3:C4
, and the last thing, False , tells us to look for an exact match rather than the nearest
The Look Up value in this example is Apple. It is what you are looking up in the table. In other words you are looking for it in the table so as to get some information about it, in this case, the information of it’s cost
I don’t know how you would use VLookUp to order something. That would depend on exactly what you want to do. Maybe the order would somehow depend on the value of something you are trying to look up. So an example showing what you want to do would be essential for anyone trying to help.
Reply With Quote
Bookmarks