IF/OR, logical tests

if i select f column details in c column by dropdown list all other details are change according to f column other details in column c, if i select g column in c column by drop dropdown list all other details are change according to G column other details in column c.

Sample File attached herewith.

Thanks in advance

Hi aejaz,

Welcome to the forum.

Would suggest you to use a sample workbook to explain your query. Click on "Go Advanced" and look for paper clip icon to attach .. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

In C23 and copied down:

=if(HLOOKUP(C$22,$F$22:$H$31,ROW(A2),0)="","",HLOOKUP(C$22,$F$22:$H$31,ROW(A2),0))