 SOLVED

# VLOOKUP #Value! error (includes using INDEX function)

Hi,

I'm trying to create a cell calculation worksheet that will calculate the number and size of flasks that I need to seed a given number of plates. For example, if I wanted to seed 10 plates, the worksheet would calculate how the size and amount of flasks I need to do that.

The formula that I am using is:

=ROUNDUP((C7/((MIN(INDEX(\$C\$25:\$D\$29,2,FALSE))))), 0)

It returns the number of flasks I need to use to seed the plates.

However, I can't figure out how to get it so it will tell me the size of flask I need it to use.

The table that the INDEX function is referencing is: (This table tells me how many plates can be seeded by each flask size. E.g., One T225 flask can seed 11 plates).

 Flask Size Plates per Flask T225 11 T175 10 T150 6 T75 6

I'm having trouble, getting the flask size to correspond with the value given for the number of flasks need. So in this example, 2XT225 flasks would seed 20 plates (because the T225 flask size was the value given based on the calculation above) NOTE: It could also work for the T175 flask, but the issue is the same.

2 Replies
best response confirmed by tanoya (New Contributor)
Solution

# Re: VLOOKUP #Value! error (includes using INDEX function)

@tanoya That calls for an XLOOKUP function, see attached.

# Re: VLOOKUP #Value! error (includes using INDEX function)

Thanks! That fixed it!