formula-seeker

Thanks for asking. Basically, I want to create an excel sheet, the information in table or image is illustration coz can't post here original information. I'll use sql statement in VBA code to access required data from table in sql server. like... I have some other excel sheets using SELECT and INNER JOIN statements. Now Im looking for sql statement to work similar like VLOOKUP, just difference is that data will be accessed from table rather than other sheets.

Sorry for not being very clear. I made this post now more clear, Please ignore my first post. >Columns A to E is an example of data with headings in table "info" in sql server. >Columns H & I is an excel sheet. What i want When I add ID number in H2 cell then sql statement should access current status of this ID from table info and show up in i2 cell. Please see image, the status of ID 1 is Employed in Status Column in info table, and ID 2 is Unemployed . >if I add ID number 1 in excel sheet in cell no H2, the status Employed should show up in i2 cell. or whatever status is available. >if I change ID number in H2 and added ID number 2 , the current status should show "unemployed " or whatever is. it is same like vlookup. Please help. Thanks

Hi All, I'm new to this forum and new to SQL. I have table in sql server " info". J2 returns the value of ID using INDEX Match formula. I want to access"Status" of ID in K2 using sql statement. When I change name in I2 cell,the ID value changed in J2 cell then the current status (that keep changing a few times in a hour ) from server "info" table should come up relating to ID available in J2 cell . like " Employed" Please see attached file for detail. I just need sql statement similar like Vlookup to access specific information from table. Thanks in Advance. Regards