Not sure which formula to use? please help

Bexster05 - Apr 4, 2016 at 05:23 AM
 Blocked Profile - Apr 4, 2016 at 05:18 PM

I need a formula to work out the following:

30 meters = 7 squares
60 meters = 14 squares
90 meters = 21 squares
etc etc
so when I type in 30 (etc) in B5 I want the 7 to come up automatically in B7 and so on is this an IF sum?

Im not very good at this so please help

Thanks Becky


1 response

Blocked Profile
Apr 4, 2016 at 05:18 PM
This could be solved with a VLOOKUP formula.

The syntax is as follows:
VLOOKUP (lookup_value, table_array, col_index_num)

So if we wanted to check our cell against another table, we would put that table range in the "Table_Array" variable. the lookup value would be one of the three you were looking for. The third part is the most confusing, it will return the value on the table_array that corresponds with the INDEX of the listing that matches FOR THE COLUMN THAT YOU SET! see the attached: