Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple columns using Vlookup
Hi! All
I have data in Sheet 1like Its a code 5848606 9659285 8100949 4846771 7201303 And in Sheet2 i have master Sheet. Data Range A1:Z600 Now i want to Pickup the Data From Sheet 2 i.e B2 to Z2 to Sheet1 I use VLOOKUP(A1,Sheet2!a2:b600,2,false) It Work Fine for me . Is it possible to use only one Formula Or i have to type one by one Vlookup Formula to pickup data from column in sheet2 Like VLOOKUP(A1,Sheet2!a2:b600,2,false) VLOOKUP(A1,Sheet2!a2:c600,3,false) VLOOKUP(A1,Sheet2!a2:d600,4,false) VLOOKUP(A1,Sheet2!a2:e600,5,false) And so on Thanks in Advance Hardeep kanwar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP on multiple columns | Excel Discussion (Misc queries) | |||
vlookup with multiple columns | Excel Discussion (Misc queries) | |||
vlookup for multiple columns | Excel Worksheet Functions | |||
Multiple Columns & VLookup?? | Excel Worksheet Functions | |||
vlookup for multiple columns | Excel Worksheet Functions |