Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can VLOOKUP identify between multiple choices for > 1 batch?
We are a manufacturing unit and produce mulitple items from one job. So Job
"A" may result in products "B" & "C". VLOOKUP will only find the first instance when running stock reports as it only searches on 1 column. Is there a way to have this function look at multiple (2 columns) and return a value? |
#2
|
|||
|
|||
Hi Ivan,
Is there a way to have this function look at multiple (2 columns) and return a value? you can add a column to your data that combines the 2 columns just by eg. formula in A1 =B1&C1. if this formula is in the first column of your data, vlookup will find it. However, this will only work correctly if B1&C1 is a unique value. arno |
#3
|
|||
|
|||
"Ivan Thorn" <Ivan ha scritto nel messaggio
We are a manufacturing unit and produce mulitple items from one job. So Job "A" may result in products "B" & "C". VLOOKUP will only find the first instance when running stock reports as it only searches on 1 column. Is there a way to have this function look at multiple (2 columns) and return a value? Maybe you can find some ideas at Chip Pearson's site: http://www.cpearson.com/excel/lookups.htm -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
#4
|
|||
|
|||
Thankyou, I feel so stupid to have missed this, but it works a treat
Thanks again "arno" wrote: Hi Ivan, Is there a way to have this function look at multiple (2 columns) and return a value? you can add a column to your data that combines the 2 columns just by eg. formula in A1 =B1&C1. if this formula is in the first column of your data, vlookup will find it. However, this will only work correctly if B1&C1 is a unique value. arno |
#5
|
|||
|
|||
Hi Ivan,
...it works a treat glad to hear that. However, pls. consider the link franz suggested. in my solution you need an extra column with formulas with the "key" to the database and a simple lookup. the other solution does not require an extra column, however, the lookup is a bit tricky. arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
vlookup with multiple lines of same value | Excel Worksheet Functions | |||
vlookup over multiple worksheets | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions |