Xlookup Combo Box

[andyjn89]

Hi New here and looking for help,

I have 2 columns, 1 with Time and 1 with Pressure. I am using a Combo Box to select the Start Time. I then use a Mod formula to get the Time in correct format.

I then want to use Xlookup to get the pressure reading at the Time selected but get #N/A error. I have tried this formula using the raw data and it works fine.

Thanks Andy

 

[awoohaw]

A sample of your workbook could help. The xl2bb add in is very helpful in that regard.

But, if the lookup works with out the data manipulation, it seems that that is the problem. Just don't do that mod formula.

 

[andyjn89]

I have removed the data mani

A sample of your workbook could help. The xl2bb add in is very helpful in that regard.

But, if the lookup works with out the data manipulation, it seems that that is the problem. Just don't do that mod formula.

I have removed the data manipulation and the Xlookup has worked. Thanks Awoohaw