Formula for Pulling Data From Sheet 2 Based on Cell Value in Sheet 1

[samgenovese03]

In excel I have sheet 1 and 2. Basically if the cell value in sheet 1 is either (s) or (c) I want to pull a value from sheet 2 based on the (s) or (c).

So to break it down in sheet one I have the baseplate geometry and it can either be sqaure (s) or circular (c), based on if that cell says (s) or (c) I want to pull data from sheet 2 that has the estimated weight of the baseplate. The estimated weight is two separate values, the weight for if its sqaure and the weight for if its a circle, which is in two different columns.

I need to find a formula that lets me pull the value of the estimated weight from sheet 2 into a cell in sheet one based off if in the cell for the baseplate geometry in sheet 1 says (s) or (c).


Sorry if this is a simple ask, but I'm a complete noob at excel, hopefully this all makes sense!

Cheers

 

[Kaper]

A lot depends on a layout of your data.
If for instance in sheet1 you have a column A with some parameter (size?) and column B with c/s (type circel or square)
And in sheet2 you have columns A size, B weight of square baseplate C weight of circular one then in C2 (I assume row 1 is for headers) you can use formula:

=VLOOKUP(A1,Sheet2!A:C,IF(B2="s",2,3),0)