# Formula comparing 2 tables

1. ## Formula comparing 2 tables

Capture.JPG

Table is in attached picture.

I need formula comparing these to two tables and the functioning as below

A2 <= E3 and B2 = F1 then C2=F3

A values will differ not exactly 2048 & 4096 it may be 2570

i have tried this

=INDEX(\$E\$1:\$M\$6,IF(A5<=\$E\$1:\$E\$6,\$E\$1:\$E\$6),MATCH(B5,E\$1:M\$1,0))

if should be looped until it is true..

The value of A2(=2048) should be compared to E3 to E6. IFA2 is less or equal to E3 (A2 <= E3) then we will consider E3 row .  Register To Reply

2. ## Re: Formula comparing 2 tables

Try this, C2 copy down

=VLOOKUP(A2,\$E:\$M,MATCH(B2,E\$1:M\$1,0))  Register To Reply

3. ## Re: Formula comparing 2 tables

It worked out, but if A2 values is 3456 it should check in value 4096 row, but it is taking 2048 row

The Memory over head value for 3456 is 324.99

2048 1 137.81
4096 1 165.98
4096 2 242.51
3456 4 280.53
4096 2 242.51
4096 1 165.98  Register To Reply

4. ## Re: Formula comparing 2 tables

Try:

=INDEX(\$E\$4:\$M\$8,MATCH(TRUE,INDEX(\$E\$4:\$E\$8>=A2,0),0),MATCH(B2,E\$1:M\$1,0))  Register To Reply

5. ## Re: Formula comparing 2 tables

Try this,

=HLOOKUP(B2,E\$1:M\$6,MATCH(A2,E\$1:E\$6)+(LOOKUP(A2,E\$1:E\$6)<A2),0)  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 