If "1" "2" or "3" is entered into "Comp" column on comp list. Info in that Row will be entered to "Comp Grid" under Sale 1/2/3.

[TheRealMccoy]

I want to be able to select comps off of "Comp List" and the information in that row will be entered "Comp Grid". If I enter a "1" in the Comp Column in "Comp List" that information will pull to "Sale 1" on "Comp Grid" sheet.
Any help is much appreciated. As of now I am just copy/paste or just re-writing all the information into the Comp Grid.
Thank you!

COMP LIST

COMP GRID

 

[SanjayGMusafir]

I want to be able to select comps off of "Comp List" and the information in that row will be entered "Comp Grid". If I enter a "1" in the Comp Column in "Comp List" that information will pull to "Sale 1" on "Comp Grid" sheet.
Any help is much appreciated. As of now I am just copy/paste or just re-writing all the information into the Comp Grid.
Thank you!

COMP LIST
View attachment 70075

COMP GRID
View attachment 70076

from What I understand, It is not difficult to pull data in Excel 365. You have to use XLOOKUP function - LookUp Value 1 in Comp List Comp Column and Return Array the column from where you want to pull the data.