Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to do an EXACT LOOKUP
I want to compare Column A from two worksheets, and copy Column B from the
second into Column B if they are exact. For cell A1, if I use =LOOKUP(A1,'Report'!A$2:A$6500,'Report!B$2:B$6500) , I end up getting the 'closest fit', but I would rather have blanks if they do not exactly match. If I use something like =IF(EXACT(A1,'Report'!A$2:A$6500),'Report'!B$2:B$6 500,""), then the formula gives me the last value in the array comparison, which is always blank. I can probably combine the LOOKUP with an AND IF(EXACT) somehow that will weed out the ones I don't want, but there has to be a simple formula or function for this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to do an EXACT LOOKUP
Don't use LOOKUP, use VLOOKUP.
If you require an exact match, the 4th argument should be set to FALSE Look in HELP for details -- Kind regards, Niek Otten Microsoft MVP - Excel "archsmooth" wrote in message ... |I want to compare Column A from two worksheets, and copy Column B from the | second into Column B if they are exact. For cell A1, if I use | =LOOKUP(A1,'Report'!A$2:A$6500,'Report!B$2:B$6500) , I end up getting the | 'closest fit', but I would rather have blanks if they do not exactly match. | If I use something like | =IF(EXACT(A1,'Report'!A$2:A$6500),'Report'!B$2:B$6 500,""), then the formula | gives me the last value in the array comparison, which is always blank. | | I can probably combine the LOOKUP with an AND IF(EXACT) somehow that will | weed out the ones I don't want, but there has to be a simple formula or | function for this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup and Match with not exact numbers | Excel Worksheet Functions | |||
Match - Exact - Lookup? | Excel Worksheet Functions | |||
Lookup returns message box when an exact match is not found | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions |