Solved: Lookup and return value based on another value

[dattagal]

THis is probably very simple for someone who knows how to do it but I am about to pull my hair out.

I searched help in Excel and this forum and cannot find what I need so I am going to post.

I have two columns in one sheet (POD Order Detail) that have an order number and a subtotal. The order number is repeated in another sheet and I want Excel to look up the order number in POD Order Detail and populate (ColJ) with the subtotal that corresponds with the POD Order Detail order number.

For example, in POD Order Detail I have an order number column (B) and in column (E) there is a subtotal.

In DailyStatusRpt I have the order number again (column A) and I want Excel to look up the subtotal in POD Order Detail that Corresponds with that same order number in POD Order Detail and put it in Column J.

:banghead: I hope this makes sense.

Ergh!!! If I could just use Access!!! I don't know Excel very well.

I would appreciate your help tremendously.

[mdmackillop]

Hi Dattagal, can you post a sample?

[dattagal]

Okay, I'll try. Lets say I have:

Order# Subtotal
5000

[mdmackillop]

Hmmmm:think:

[dattagal]

Okay, I'll try. Lets say I have the following in one sheet (ODON):

Col A Col E
Order# Subtotal
5000 $56.35
5280 $20.00
5359 $ 2.59

In another sheet (same workbook) (DSON) I have:
Col B Col J
Ord# STotal
5000 $56.35
5357

I want Excel to look in ColA of the ODON Worksheet (formerly named POD Order Detail), find the 5000 and put $56.35 in Col J in the DSON worksheet.

[dattagal]

Oops, looks like I hit the enter key at the wrong time - disregard the post with hardly any data.

[Bob Phillips]

:rotlaugh:

[mdmackillop]

Inset this in J2 and copy down
=VLOOKUP(B2,ODON!A:E,5,FALSE)

[dattagal]

That's it!!! Thank you so much!!!

[mdmackillop]

Happy to help.