Formula question

[czah7]

[FONT=&quot]I have two tabs, lets call them White and Black.[/FONT]
[FONT=&quot]In White I will record data, I.E cell A1 is a name, Chris. cell B1 is a number, 200. cell A2 is Jen. cell B2 is 300[/FONT]
[FONT=&quot]In my Black tab I have the same column A, Chris, Jen, etc. But column B i need it to pull directly from Chris’s or Jen’s respective Column B. But with the assumption that the tab White will be sorted and reordered sometimes.[/FONT]
[FONT=&quot]So essentially I need black to have a forula that says “In column B, look at the name in column A, match that name to the tab white, and grab the value in it’s column B”[/FONT]

 

[philwojo]

This would be a simple VLookup formula, i would suggest giving it a try and posting back if you need help.