I have Excel 2007 and can not figure out which formula I need to complete a file.  Here is what I need it to do:  In the example below, I need the Formula to use the value in TAB A, Col A, correposponding Row, then seach TAB B, Col A for an idential match (to the value in TAB A, Col A), then give the value located in its corresponding Row in TAB B (TAB B, Col C, Row 2)- in this case $500.  Can you help me figure this out?

TAB A
    Col A  Col B  Col C etc
Row1    55        Formula
Row2    ..          ...
etc

TAB B
    Col A  Col B Col C etc
Row1     45       $300  
Row2     55       $500      
etc

---

Richard Answers:

This is exactly what VLOOKUP is used for. See this tutorial:

http://www.599cd.com/tips/excel/vlookup/

In your case you want to use the EXACT MATCH option. So your formula for B1 would be:

=VLOOKUP(A1,Sheet2!A1:Sheet2!B2,2,FALSE)

This says look at the range on Sheet2 from A1 to B2 (which will most likely be larger for your actual sheet) and find the value in A1 (on the current sheet). Now, bring back the 2nd column ($500 in this case) and it must be an EXACT match (the FALSE).

Hope this helps.