| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with v lookup
Hi
i am having an issue with Excel where I have 2 work books with the same information on both, but bits of data missing I am trying to merge them as one huge document; so were I have sheet 1 below looking like this cell A BN55VRP cell B BN55VRP cell Q 1984 I need to make colum A & B to be primary Keys or point of references so that when I merge sheet 2 to sheet 1 they match i dentically. I was using v lookup formula but this is not working formula A2,=VLOOKUP($A$1,SHEET1!:$B$100,2,0) then the same fomula for sheet 2 but changing A3 except changing to sheet 2! instead of sheet one. Can some one help please this is driving me mad!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
