IF(ISERROR(MATCH - need value where match was found

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I'm trying to work up a formula that will look at the value in a cell, find
it in a column on another sheet, and when found pull the value from the same
row, different column where the match was found. Here's what I have so far:

=IF(ISERROR(MATCH($B2,'[TIRs 11-06-03.xls]Sheet1'!$C$2:$C$12000,0)),0, ????

So if the match for the value in B2 was found in C100, the formula would
pull the value from G100.

Any assistance is appreciated.

Ed
 
Ed,

Have you looked at the VLOOKUP function?

Give the following a try...

=IF(ISERROR(VLOOKUP(B2,C2:G1200,5,False)),0,VLOOKUP(B2,C2:G1200,5,False))

Dan E
 
Thank you. I'll try that.

Ed

Dan E said:
Ed,

Have you looked at the VLOOKUP function?

Give the following a try...

=IF(ISERROR(VLOOKUP(B2,C2:G1200,5,False)),0,VLOOKUP(B2,C2:G1200,5,False))

Dan E

I'm trying to work up a formula that will look at the value in a cell, find
it in a column on another sheet, and when found pull the value from the same
row, different column where the match was found. Here's what I have so far:

=IF(ISERROR(MATCH($B2,'[TIRs 11-06-03.xls]Sheet1'!$C$2:$C$12000,0)),0, ????

So if the match for the value in B2 was found in C100, the formula would
pull the value from G100.

Any assistance is appreciated.

Ed
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer array element offset value to a matched value 3
Match Value and Show MsgBox 1
MATCH() and ISERROR() to extract set differences 1
Find a value in a sheet and replace it with another value if it matches 8
Match Values and Highlite row 2
Create if partial match then copy and paste data from one cell to another 1
HELP! Lost data - need to insert formula but get error! 9
With F1 value, look at A, if match or partial match return B 5

Back
Top