Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match or vlookup?
Dear all
I am working with excel xp edition i have a workbook which involve 9 sheets with the same format. in column B of each sheet there is a 6 digit code (620035) and in the column c, d, e there are some values. I am working in another sheet which i have the same format with the others. In column b i have all the codes from the other sheets. There is any possibility to use match or vlookup function in order to say if the code form sheet 10 is equal with code in sheets 1,2,3,4,5,6,7,8,9 then add the appropriate values in column c, form respective columns C? Thanks in advance Manos |
#2
|
|||
|
|||
MATCH() returns the row that the match was found in. VLOOKUP() returns
the corresponding value in a specified column. From your description it sounds like you want VLOOKUP. Jerry Manos wrote: Dear all I am working with excel xp edition i have a workbook which involve 9 sheets with the same format. in column B of each sheet there is a 6 digit code (620035) and in the column c, d, e there are some values. I am working in another sheet which i have the same format with the others. In column b i have all the codes from the other sheets. There is any possibility to use match or vlookup function in order to say if the code form sheet 10 is equal with code in sheets 1,2,3,4,5,6,7,8,9 then add the appropriate values in column c, form respective columns C? Thanks in advance Manos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
Vlookup, index, match? | Excel Worksheet Functions | |||
Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |