VLOOKUP

[eramirez148]

Is there a formula that can give me the following results in column C in table 1. Basically I wanted table 1 column c to look for the description from column a table 1 in table 2 and trace column B and add that number to column B from tab;e 1

Example
Table 1 "A2" Chiller Fresh the results in column C "listing" is 7/1/2023 because it is finding in table two column B that listing is -25 so column C in table 1 takes into account column "B" 7/26/2023 and deducts -25 for chiller/fresh.

Table 1

	A	B	C
1​			Listing
2​	Chiller/Fresh	7/26/2023	7/1/2023​
3​	Freezer	7/26/2023	6/28/2023​
4​	Ambient	7/26/2023	7/2/2023​

Table 2

	A	B	C
1​		Listing	Master Data Check Start
2​	Chiller/Fresh	-25​	-27​
3​	Freezer	-28​	-27​
4​	Ambient	-24​	-27​

 

[Fluff]

What version of Excel are you actually using? You cannot be using every single version.

 

[Joe4]

I recreated your example like this:

and put this formula in cell D4 and copied down to D6:

=C4+VLOOKUP(B4,B$12:C$14,2,0)

 

[eramirez148]

Wow this worked perfectly thank you Joe4

 

[Joe4]

You are welcome.
Glad we were able to help.