match data and return another data

August 2, 2010 at 12:17:34
Specs: Windows XP
Hi. I have a problem here.
I would like to match a name between sheet 1 and sheet 2 of my worksheets. Let says if a name on sheet1 is in A1, and the same name appears on sheet2 is in, let says A10. I want them to return another value near A10 (after it found a match), let says B12, Can I do so?

See More: match data and return another data

Report •

August 2, 2010 at 12:32:49
Where is the "other value" for B12 coming from. Is it hardcoded into the formula or being pulled from a table/list?

Is your offset always going to be 2 Rows and 1 Column?

i.e. Found in A10, value goes in B12; found in A5, value goes in B7, etc.

Report •

August 2, 2010 at 12:38:48

the data in B12 were pulled from another table (with no formulas, just plain text) and the offset will be in the same patterns, always.

Report •
Related Solutions

Ask Question