Match data from one cell to a range on another worksheet and return value

[Ninja79]

look for Worksheet A A4 value on a range in worksheet B, if it matches, return the value to Worksheet A C4

[Sam Capricci]

sounds like a VLOOKUP would work for you. Something like =vlookup(a4,'worksheet'!B:B,1,false) based on the info you provided so far (in cell C4).

EDIT: and if it is a range then make it something like this... =vlookup(a4,'worksheet'!B:C,2,false)

[63falcondude]

Here's another option:

C4 =IF(MATCH(A4,'worksheet B'!A:A,0),A4,"No Match")

This assumes that your range is column A.


If your range is made up of multiple columns, you can use this:

C4 =IF(COUNTIF('worksheet B'!A:B,A4),A4,"No Match")

[Ninja79]

Thank you. I dont think I was clear in my question.

Worksheet A - Column A is a note rates for a certain product
Worksheet B - note rates for various products at multiple lock periods

I want to look for the value in column A on worksheet A in a range on worksheet B and if there is a match, return value for column index number 5 from worksheet B to column C on worksheet A

[63falcondude]

I dont think I was clear in my question.

No, you were not. Unfortunately, what you are looking for still isn't clear (at least not to me).

Attach a sample workbook. Make sure there is just enough data to demonstrate your need.
Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Ninja79]

Thank you. My first time using this forum. I'll add attachment.

[Ninja79]

I'm trying to get corresponding pricing for Ratesheet Calc A4 from the range in cash pricing for 30-year fixed rate and return the 50 day price in ratesheet calc C4.

thank you all.

[63falcondude]

You didn't include any of the desired results of the formula.

Try this in C4:

=INDEX('Cash Pricing'!D:D,MATCH(A4,'Cash Pricing'!B:B,0))

[Sam Capricci]

this looks like it will do it for you... =VLOOKUP(A4,'Cash Pricing'!B:D,3,FALSE)

[Ninja79]

I'm failing miserably today. But this got me the result I was looking for. Thank you very much Sambo kid and 63falcondude

[63falcondude]

Cheer up, the world is your oyster!

Glad we could help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.